Pandas Profiling Report

Dataset statistics

Number of variables	13
Number of observations	3040
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	297.0 KiB
Average record size in memory	100.0 B

Variable types

Numeric	13

Alerts

`gross_revenue` is highly correlated with `qtde_invoices` and 5 other fields	High correlation
`recency_days` is highly correlated with `qtde_invoices`	High correlation
`qtde_invoices` is highly correlated with `gross_revenue` and 2 other fields	High correlation
`qtde_items` is highly correlated with `gross_revenue` and 5 other fields	High correlation
`qtde_products` is highly correlated with `gross_revenue` and 2 other fields	High correlation
`avg_ticket` is highly correlated with `gross_revenue` and 3 other fields	High correlation
`avg_recency_days` is highly correlated with `frequency`	High correlation
`frequency` is highly correlated with `avg_recency_days`	High correlation
`avg_basket_size` is highly correlated with `gross_revenue` and 3 other fields	High correlation
`avg_unique_basket_size` is highly correlated with `customer_id`	High correlation
`qtde_returns` is highly correlated with `gross_revenue` and 3 other fields	High correlation
`customer_id` is highly correlated with `avg_unique_basket_size`	High correlation
`avg_ticket` is highly skewed (γ1 = 39.09010284)	Skewed
`qtde_returns` is highly skewed (γ1 = 38.01023083)	Skewed
`avg_basket_size` is highly skewed (γ1 = 40.99969797)	Skewed
`df_index` has unique values	Unique
`customer_id` has unique values	Unique
`recency_days` has 90 (3.0%) zeros	Zeros
`avg_recency_days` has 81 (2.7%) zeros	Zeros
`qtde_returns` has 1535 (50.5%) zeros	Zeros

Reproduction

Analysis started	2022-09-27 11:35:53.146746
Analysis finished	2022-09-27 11:37:56.375025
Duration	2 minutes and 3.23 seconds
Software version	pandas-profiling v3.3.0
Download configuration	config.json

df_index
Real number (ℝ_≥0)

UNIQUE

Distinct	3040
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2327.782566

Minimum	0
Maximum	5677
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	23.9 KiB

Quantile statistics

Minimum	0
5-th percentile	190.95
Q1	956.5
median	2134.5
Q3	3537
95-th percentile	5058.05
Maximum	5677
Range	5677
Interquartile range (IQR)	2580.5

Descriptive statistics

Standard deviation	1546.466985
Coefficient of variation (CV)	0.6643519922
Kurtosis	-1.021504017
Mean	2327.782566
Median Absolute Deviation (MAD)	1274
Skewness	0.3235780558
Sum	7076459
Variance	2391560.135
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1	< 0.1%
3035	1	< 0.1%
3022	1	< 0.1%
3023	1	< 0.1%
3024	1	< 0.1%
3028	1	< 0.1%
3029	1	< 0.1%
3031	1	< 0.1%
3032	1	< 0.1%
3033	1	< 0.1%
Other values (3030)	3030	99.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%

Value	Count	Frequency (%)
5677	1	< 0.1%
5675	1	< 0.1%
5624	1	< 0.1%
5607	1	< 0.1%
5597	1	< 0.1%
5592	1	< 0.1%
5591	1	< 0.1%
5585	1	< 0.1%
5570	1	< 0.1%
5568	1	< 0.1%

customer_id
Real number (ℝ_≥0)

HIGH CORRELATION
UNIQUE

Distinct	3040
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15306.15099

Minimum	12346
Maximum	22269
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	12.0 KiB

Quantile statistics

Minimum	12346
5-th percentile	12620.95
Q1	13815.75
median	15255
Q3	16804.25
95-th percentile	18008.05
Maximum	22269
Range	9923
Interquartile range (IQR)	2988.5

Descriptive statistics

Standard deviation	1744.410149
Coefficient of variation (CV)	0.1139679173
Kurtosis	-1.015418269
Mean	15306.15099
Median Absolute Deviation (MAD)	1493.5
Skewness	0.08263686169
Sum	46530699
Variance	3042966.769
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
17850	1	< 0.1%
15128	1	< 0.1%
13282	1	< 0.1%
15582	1	< 0.1%
16230	1	< 0.1%
18146	1	< 0.1%
15976	1	< 0.1%
12886	1	< 0.1%
17974	1	< 0.1%
13524	1	< 0.1%
Other values (3030)	3030	99.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
12346	1	< 0.1%
12347	1	< 0.1%
12348	1	< 0.1%
12352	1	< 0.1%
12356	1	< 0.1%
12358	1	< 0.1%
12359	1	< 0.1%
12360	1	< 0.1%
12362	1	< 0.1%
12364	1	< 0.1%

Value	Count	Frequency (%)
22269	1	< 0.1%
21354	1	< 0.1%
20532	1	< 0.1%
20357	1	< 0.1%
20296	1	< 0.1%
20055	1	< 0.1%
19853	1	< 0.1%
19787	1	< 0.1%
19673	1	< 0.1%
19589	1	< 0.1%

gross_revenue
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	3023
Distinct (%)	99.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2749.080507

Minimum	6.2
Maximum	279138.02
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.9 KiB

Quantile statistics

Minimum	6.2
5-th percentile	216.49
Q1	552.78
median	1067.485
Q3	2281.3525
95-th percentile	7237.1505
Maximum	279138.02
Range	279131.82
Interquartile range (IQR)	1728.5725

Descriptive statistics

Standard deviation	10576.89307
Coefficient of variation (CV)	3.847429365
Kurtosis	346.9449453
Mean	2749.080507
Median Absolute Deviation (MAD)	668.135
Skewness	16.53361436
Sum	8357204.74
Variance	111870667
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1025.44	2	0.1%
734.94	2	0.1%
1314.45	2	0.1%
2053.02	2	0.1%
745.06	2	0.1%
379.65	2	0.1%
533.33	2	0.1%
331	2	0.1%
2092.32	2	0.1%
1078.96	2	0.1%
Other values (3013)	3020	99.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
6.2	1	< 0.1%
13.3	1	< 0.1%
15	1	< 0.1%
17.11	1	< 0.1%
25.5	1	< 0.1%
36.56	1	< 0.1%
45	1	< 0.1%
52	1	< 0.1%
52.2	1	< 0.1%
52.2	1	< 0.1%

Value	Count	Frequency (%)
279138.02	1	< 0.1%
259657.3	1	< 0.1%
194550.79	1	< 0.1%
168472.5	1	< 0.1%
140450.72	1	< 0.1%
124564.53	1	< 0.1%
117379.63	1	< 0.1%
91062.38	1	< 0.1%
77183.6	1	< 0.1%
72882.09	1	< 0.1%

recency_days
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	310
Distinct (%)	10.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	65.91809211

Minimum	0
Maximum	372
Zeros	90
Zeros (%)	3.0%
Negative	0
Negative (%)	0.0%
Memory size	23.9 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	11
median	32
Q3	85
95-th percentile	252.05
Maximum	372
Range	372
Interquartile range (IQR)	74

Descriptive statistics

Standard deviation	79.95689157
Coefficient of variation (CV)	1.212973389
Kurtosis	2.43915936
Mean	65.91809211
Median Absolute Deviation (MAD)	26
Skewness	1.736986768
Sum	200391
Variance	6393.10451
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3	99	3.3%
0	90	3.0%
2	84	2.8%
1	82	2.7%
7	72	2.4%
9	67	2.2%
8	64	2.1%
10	60	2.0%
4	60	2.0%
15	59	1.9%
Other values (300)	2303	75.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	90	3.0%
1	82	2.7%
2	84	2.8%
3	99	3.3%
4	60	2.0%
5	20	0.7%
6	38	1.2%
7	72	2.4%
8	64	2.1%
9	67	2.2%

Value	Count	Frequency (%)
372	3	0.1%
371	4	0.1%
369	1	< 0.1%
368	2	0.1%
366	1	< 0.1%
365	5	0.2%
363	1	< 0.1%
359	2	0.1%
357	4	0.1%
354	1	< 0.1%

qtde_invoices
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	56
Distinct (%)	1.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.628947368

Minimum	1
Maximum	206
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.9 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	3
Q3	6
95-th percentile	16
Maximum	206
Range	205
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	8.774185353
Coefficient of variation (CV)	1.558761306
Kurtosis	193.9707197
Mean	5.628947368
Median Absolute Deviation (MAD)	1
Skewness	10.84372704
Sum	17112
Variance	76.98632861
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	823	27.1%
3	503	16.5%
4	394	13.0%
5	237	7.8%
1	218	7.2%
6	173	5.7%
7	138	4.5%
8	98	3.2%
9	69	2.3%
10	55	1.8%
Other values (46)	332	10.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	218	7.2%
2	823	27.1%
3	503	16.5%
4	394	13.0%
5	237	7.8%
6	173	5.7%
7	138	4.5%
8	98	3.2%
9	69	2.3%
10	55	1.8%

Value	Count	Frequency (%)
206	1	< 0.1%
199	1	< 0.1%
124	1	< 0.1%
97	1	< 0.1%
91	2	0.1%
86	1	< 0.1%
72	1	< 0.1%
62	2	0.1%
60	1	< 0.1%
57	1	< 0.1%

qtde_items
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	1691
Distinct (%)	55.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1606.121382

Minimum	1
Maximum	196844
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.9 KiB

Quantile statistics

Minimum	1
5-th percentile	94
Q1	288
median	616
Q3	1390.25
95-th percentile	4405.2
Maximum	196844
Range	196843
Interquartile range (IQR)	1102.25

Descriptive statistics

Standard deviation	5969.833531
Coefficient of variation (CV)	3.716925507
Kurtosis	437.5386043
Mean	1606.121382
Median Absolute Deviation (MAD)	411
Skewness	17.32370424
Sum	4882609
Variance	35638912.39
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
310	11	0.4%
150	9	0.3%
88	9	0.3%
272	8	0.3%
84	8	0.3%
260	8	0.3%
288	8	0.3%
246	8	0.3%
516	7	0.2%
200	7	0.2%
Other values (1681)	2957	97.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	3	0.1%
12	2	0.1%
14	1	< 0.1%
16	1	< 0.1%
17	1	< 0.1%
18	1	< 0.1%
19	1	< 0.1%
20	1	< 0.1%
23	1	< 0.1%

Value	Count	Frequency (%)
196844	1	< 0.1%
80997	1	< 0.1%
80263	1	< 0.1%
77373	1	< 0.1%
74215	1	< 0.1%
69993	1	< 0.1%
64549	1	< 0.1%
64124	1	< 0.1%
63312	1	< 0.1%
58343	1	< 0.1%

qtde_products
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	469
Distinct (%)	15.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	121.2904605

Minimum	1
Maximum	7838
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.9 KiB

Quantile statistics

Minimum	1
5-th percentile	9
Q1	29
median	66
Q3	134.25
95-th percentile	382
Maximum	7838
Range	7837
Interquartile range (IQR)	105.25

Descriptive statistics

Standard deviation	267.0626546
Coefficient of variation (CV)	2.201843851
Kurtosis	361.8964601
Mean	121.2904605
Median Absolute Deviation (MAD)	44
Skewness	15.84971849
Sum	368723
Variance	71322.46151
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
28	45	1.5%
20	37	1.2%
35	36	1.2%
29	35	1.2%
19	34	1.1%
15	34	1.1%
11	32	1.1%
26	32	1.1%
25	31	1.0%
27	31	1.0%
Other values (459)	2693	88.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	8	0.3%
2	14	0.5%
3	17	0.6%
4	18	0.6%
5	26	0.9%
6	30	1.0%
7	19	0.6%
8	19	0.6%
9	29	1.0%
10	28	0.9%

Value	Count	Frequency (%)
7838	1	< 0.1%
5673	1	< 0.1%
5095	1	< 0.1%
4580	1	< 0.1%
2698	1	< 0.1%
2379	1	< 0.1%
2060	1	< 0.1%
1818	1	< 0.1%
1673	1	< 0.1%
1637	1	< 0.1%

avg_ticket
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED

Distinct	3036
Distinct (%)	99.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	81.22851766

Minimum	1.901111111
Maximum	77183.6
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.9 KiB

Quantile statistics

Minimum	1.901111111
5-th percentile	4.773098383
Q1	12.61353223
median	17.86590276
Q3	24.81791667
95-th percentile	90.52168832
Maximum	77183.6
Range	77181.69889
Interquartile range (IQR)	12.20438443

Descriptive statistics

Standard deviation	1750.805944
Coefficient of variation (CV)	21.5540797
Kurtosis	1585.124574
Mean	81.22851766
Median Absolute Deviation (MAD)	6.152278326
Skewness	39.09010284
Sum	246934.6937
Variance	3065321.453
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
25.5	2	0.1%
15	2	0.1%
14.47833333	2	0.1%
4.162	2	0.1%
18.15222222	1	< 0.1%
30.59837838	1	< 0.1%
15.52068182	1	< 0.1%
15.48657143	1	< 0.1%
16.035	1	< 0.1%
4.397346939	1	< 0.1%
Other values (3026)	3026	99.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1.901111111	1	< 0.1%
2.150588235	1	< 0.1%
2.241	1	< 0.1%
2.264375	1	< 0.1%
2.4325	1	< 0.1%
2.462371134	1	< 0.1%
2.511241379	1	< 0.1%
2.515333333	1	< 0.1%
2.65	1	< 0.1%
2.656931818	1	< 0.1%

Value	Count	Frequency (%)
77183.6	1	< 0.1%
56157.5	1	< 0.1%
13305.5	1	< 0.1%
4453.43	1	< 0.1%
3202.92	1	< 0.1%
1687.2	1	< 0.1%
1377.077778	1	< 0.1%
952.9875	1	< 0.1%
872.13	1	< 0.1%
841.0214493	1	< 0.1%

avg_recency_days
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	1333
Distinct (%)	43.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	60.69481775

Minimum	0
Maximum	365
Zeros	81
Zeros (%)	2.7%
Negative	0
Negative (%)	0.0%
Memory size	23.9 KiB

Quantile statistics

Minimum	0
5-th percentile	4
Q1	21.49166667
median	41.6
Q3	76.54166667
95-th percentile	188
Maximum	365
Range	365
Interquartile range (IQR)	55.05

Descriptive statistics

Standard deviation	61.57814682
Coefficient of variation (CV)	1.014553616
Kurtosis	5.750706952
Mean	60.69481775
Median Absolute Deviation (MAD)	24.6
Skewness	2.198592687
Sum	184512.246
Variance	3791.868166
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	81	2.7%
4	28	0.9%
10	21	0.7%
38	21	0.7%
27	21	0.7%
13	20	0.7%
31	20	0.7%
7	19	0.6%
21	18	0.6%
17	16	0.5%
Other values (1323)	2775	91.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	81	2.7%
0.4	1	< 0.1%
0.5	3	0.1%
0.75	1	< 0.1%
1	12	0.4%
1.161157025	1	< 0.1%
1.377880184	1	< 0.1%
1.5	1	< 0.1%
1.838323353	1	< 0.1%
2	15	0.5%

Value	Count	Frequency (%)
365	1	< 0.1%
364	1	< 0.1%
363	1	< 0.1%
361	1	< 0.1%
356	3	0.1%
354	2	0.1%
351	2	0.1%
350	2	0.1%
349	3	0.1%
348	1	< 0.1%

frequency
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	1234
Distinct (%)	40.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.1592653739

Minimum	0.005464480874
Maximum	17
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.9 KiB

Quantile statistics

Minimum	0.005464480874
5-th percentile	0.008968609865
Q1	0.01657458564
median	0.02683278048
Q3	0.05418524712
95-th percentile	1
Maximum	17
Range	16.99453552
Interquartile range (IQR)	0.03761066148

Descriptive statistics

Standard deviation	0.508219863
Coefficient of variation (CV)	3.19102546
Kurtosis	407.7223613
Mean	0.1592653739
Median Absolute Deviation (MAD)	0.01311533354
Skewness	14.25886203
Sum	484.1667366
Variance	0.2582874291
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	210	6.9%
2	61	2.0%
0.02380952381	17	0.6%
0.0625	16	0.5%
0.01587301587	15	0.5%
0.02941176471	14	0.5%
0.01923076923	14	0.5%
0.04545454545	14	0.5%
0.07142857143	13	0.4%
0.01818181818	13	0.4%
Other values (1224)	2653	87.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.005464480874	1	< 0.1%
0.005479452055	2	0.1%
0.005494505495	1	< 0.1%
0.005602240896	3	0.1%
0.005633802817	2	0.1%
0.005681818182	1	< 0.1%
0.005698005698	3	0.1%
0.005714285714	4	0.1%
0.005730659026	1	< 0.1%
0.005747126437	1	< 0.1%

Value	Count	Frequency (%)
17	1	< 0.1%
6	1	< 0.1%
4	2	0.1%
3	4	0.1%
2	61	2.0%
1.5	1	< 0.1%
1.333333333	1	< 0.1%
1	210	6.9%
0.6666666667	3	0.1%
0.5549597855	1	< 0.1%

qtde_returns
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED
ZEROS

Distinct	215
Distinct (%)	7.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	85.21973684

Minimum	0
Maximum	80995
Zeros	1535
Zeros (%)	50.5%
Negative	0
Negative (%)	0.0%
Memory size	23.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	9
95-th percentile	98.1
Maximum	80995
Range	80995
Interquartile range (IQR)	9

Descriptive statistics

Standard deviation	2010.747881
Coefficient of variation (CV)	23.59486143
Kurtosis	1470.661412
Mean	85.21973684
Median Absolute Deviation (MAD)	0
Skewness	38.01023083
Sum	259068
Variance	4043107.043
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1535	50.5%
1	169	5.6%
2	150	4.9%
3	105	3.5%
4	89	2.9%
6	78	2.6%
5	61	2.0%
12	52	1.7%
7	44	1.4%
8	43	1.4%
Other values (205)	714	23.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1535	50.5%
1	169	5.6%
2	150	4.9%
3	105	3.5%
4	89	2.9%
5	61	2.0%
6	78	2.6%
7	44	1.4%
8	43	1.4%
9	41	1.3%

Value	Count	Frequency (%)
80995	1	< 0.1%
74215	1	< 0.1%
9014	1	< 0.1%
8004	1	< 0.1%
4427	1	< 0.1%
3768	1	< 0.1%
3332	1	< 0.1%
2878	1	< 0.1%
2022	1	< 0.1%
2012	1	< 0.1%

avg_basket_size
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED

Distinct	2002
Distinct (%)	65.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	275.5867541

Minimum	1
Maximum	74215
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.9 KiB

Quantile statistics

Minimum	1
5-th percentile	43.31666667
Q1	102.15
median	172
Q3	281.0833333
95-th percentile	604.85
Maximum	74215
Range	74214
Interquartile range (IQR)	178.9333333

Descriptive statistics

Standard deviation	1556.994657
Coefficient of variation (CV)	5.649744171
Kurtosis	1820.819008
Mean	275.5867541
Median Absolute Deviation (MAD)	83.5
Skewness	40.99969797
Sum	837783.7323
Variance	2424232.363
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
100	11	0.4%
114	10	0.3%
86	10	0.3%
82	9	0.3%
73	9	0.3%
88	8	0.3%
75	8	0.3%
60	8	0.3%
136	8	0.3%
163	7	0.2%
Other values (1992)	2952	97.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	2	0.1%
2	2	0.1%
3.333333333	1	< 0.1%
5.333333333	1	< 0.1%
5.666666667	1	< 0.1%
6.142857143	1	< 0.1%
7.5	1	< 0.1%
9	1	< 0.1%
9.5	1	< 0.1%
11	1	< 0.1%

Value	Count	Frequency (%)
74215	1	< 0.1%
40498.5	1	< 0.1%
6009.333333	1	< 0.1%
5963	1	< 0.1%
4282	1	< 0.1%
3906	1	< 0.1%
3868.65	1	< 0.1%
2880	1	< 0.1%
2801	1	< 0.1%
2733.944444	1	< 0.1%

avg_unique_basket_size
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	920
Distinct (%)	30.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	18.11154116

Minimum	0.2
Maximum	415
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.9 KiB

Quantile statistics

Minimum	0.2
5-th percentile	2
Q1	7.75
median	13.66666667
Q3	22.55
95-th percentile	47.66904762
Maximum	415
Range	414.8
Interquartile range (IQR)	14.8

Descriptive statistics

Standard deviation	18.42998867
Coefficient of variation (CV)	1.017582574
Kurtosis	90.58593197
Mean	18.11154116
Median Absolute Deviation (MAD)	6.821428571
Skewness	6.209684015
Sum	55059.08512
Variance	339.6644822
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
9	44	1.4%
13	43	1.4%
8	40	1.3%
14	39	1.3%
16	39	1.3%
17	38	1.2%
11	38	1.2%
7	36	1.2%
5	36	1.2%
15	35	1.2%
Other values (910)	2652	87.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.2	1	< 0.1%
0.25	3	0.1%
0.3333333333	7	0.2%
0.4	1	< 0.1%
0.4090909091	1	< 0.1%
0.5	12	0.4%
0.5454545455	1	< 0.1%
0.5555555556	1	< 0.1%
0.5714285714	1	< 0.1%
0.6176470588	1	< 0.1%

Value	Count	Frequency (%)
415	1	< 0.1%
259	1	< 0.1%
181	1	< 0.1%
177	1	< 0.1%
171	1	< 0.1%
160	1	< 0.1%
148	1	< 0.1%
143	1	< 0.1%
141	1	< 0.1%
138	1	< 0.1%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	df_index	customer_id	gross_revenue	recency_days	qtde_invoices	qtde_items	qtde_products	avg_ticket	avg_recency_days	frequency	qtde_returns	avg_basket_size	avg_unique_basket_size
0	0	17850	5391.21	371	34	1733	297	18.152222	2.090909	17.000000	40.0	50.970588	0.617647
1	1	13047	3232.59	56	9	1390	171	18.904035	22.928571	0.028302	35.0	154.444444	11.666667
2	2	12583	6705.38	2	15	5028	232	28.902500	22.750000	0.040431	50.0	335.200000	7.600000
3	3	13748	948.25	95	5	439	28	33.866071	92.333333	0.017921	0.0	87.800000	4.800000
4	4	15100	876.00	333	3	80	3	292.000000	8.200000	0.073171	22.0	26.666667	0.333333
5	5	15291	4623.30	25	14	2102	102	45.326471	18.888889	0.040115	29.0	150.142857	4.357143
6	6	14688	5630.87	7	21	3621	327	17.219786	13.730769	0.057221	399.0	172.428571	7.047619
7	7	17809	5411.91	15	12	2057	61	88.719836	27.153846	0.033520	41.0	171.416667	3.833333
8	8	15311	60767.90	0	91	38194	2379	25.543464	2.735043	0.243316	474.0	419.714286	6.230769
9	9	16098	2005.63	87	7	613	67	29.934776	40.285714	0.027875	0.0	87.571429	4.857143

Last rows

	df_index	customer_id	gross_revenue	recency_days	qtde_invoices	qtde_items	qtde_products	avg_ticket	avg_recency_days	frequency	qtde_returns	avg_basket_size	avg_unique_basket_size
3030	5568	17852	114.34	11	2	53	24	4.764167	0.0	2.000000	0.0	26.500000	10.500000
3031	5570	12479	473.20	10	1	382	30	15.773333	3.5	1.000000	34.0	382.000000	30.000000
3032	5585	17772	182.77	10	2	58	53	3.448491	0.0	2.000000	0.0	29.000000	25.000000
3033	5591	14126	706.13	7	3	508	15	47.075333	1.0	1.000000	50.0	169.333333	4.666667
3034	5592	16479	300.83	9	2	102	35	8.595143	0.0	2.000000	0.0	51.000000	17.500000
3035	5597	13521	1092.39	0	3	733	435	2.511241	3.5	0.333333	0.0	244.333333	104.000000
3036	5607	15060	301.84	7	4	262	120	2.515333	0.0	4.000000	0.0	65.500000	20.000000
3037	5624	12558	269.96	7	1	196	11	24.541818	5.0	1.000000	196.0	196.000000	11.000000
3038	5675	16000	12393.70	2	3	5110	9	1377.077778	0.0	3.000000	0.0	1703.333333	3.000000
3039	5677	14087	194.42	2	1	251	69	2.817681	0.0	1.000000	1.0	251.000000	61.000000

Overview

Variables

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows